{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "003969d8-cd0c-4b04-adcc-582035558777",
   "metadata": {},
   "outputs": [],
   "source": [
    "import polars as pl\n",
    "from perspective.widget import PerspectiveWidget"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f451a95c-97f1-45be-9465-08a1a5d18945",
   "metadata": {},
   "outputs": [],
   "source": [
    "d1 = pl.read_parquet(\"new_share.parquet\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "85be20ae-a42b-4a73-b4a3-4f3c9b82d158",
   "metadata": {},
   "outputs": [],
   "source": [
    "d2 = pl.read_parquet(\"stock.basic.parquet\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e3ba27ed-330a-4421-a008-9272757187ad",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><style>\n",
       ".dataframe > thead > tr,\n",
       ".dataframe > tbody > tr {\n",
       "  text-align: right;\n",
       "  white-space: pre-wrap;\n",
       "}\n",
       "</style>\n",
       "<small>shape: (2_000, 12)</small><table border=\"1\" class=\"dataframe\"><thead><tr><th>ts_code</th><th>sub_code</th><th>name</th><th>ipo_date</th><th>issue_date</th><th>amount</th><th>market_amount</th><th>price</th><th>pe</th><th>limit_amount</th><th>funds</th><th>ballot</th></tr><tr><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>f64</td><td>f64</td><td>f64</td><td>f64</td><td>f64</td><td>f64</td><td>f64</td></tr></thead><tbody><tr><td>&quot;001221.SZ&quot;</td><td>&quot;001221&quot;</td><td>&quot;悍高集团&quot;</td><td>&quot;20250721&quot;</td><td>null</td><td>4001.0</td><td>0.0</td><td>0.0</td><td>0.0</td><td>1.05</td><td>0.0</td><td>0.0</td></tr><tr><td>&quot;301609.SZ&quot;</td><td>&quot;301609&quot;</td><td>&quot;山大电力&quot;</td><td>&quot;20250714&quot;</td><td>null</td><td>4072.0</td><td>1038.0</td><td>14.66</td><td>19.57</td><td>1.0</td><td>5.97</td><td>0.0</td></tr><tr><td>&quot;603262.SH&quot;</td><td>&quot;732262&quot;</td><td>&quot;技源集团&quot;</td><td>&quot;20250714&quot;</td><td>null</td><td>5001.0</td><td>1200.0</td><td>10.88</td><td>25.51</td><td>1.2</td><td>5.441</td><td>0.0</td></tr><tr><td>&quot;600930.SH&quot;</td><td>&quot;730930&quot;</td><td>&quot;华电新能&quot;</td><td>&quot;20250707&quot;</td><td>null</td><td>571429.0</td><td>144928.0</td><td>3.18</td><td>15.56</td><td>149.05</td><td>181.714</td><td>0.56</td></tr><tr><td>&quot;301630.SZ&quot;</td><td>&quot;301630&quot;</td><td>&quot;同宇新材&quot;</td><td>&quot;20250701&quot;</td><td>&quot;20250710&quot;</td><td>1000.0</td><td>1000.0</td><td>84.0</td><td>23.94</td><td>1.0</td><td>8.4</td><td>0.01</td></tr><tr><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td></tr><tr><td>&quot;603867.SH&quot;</td><td>&quot;732867&quot;</td><td>&quot;新化股份&quot;</td><td>&quot;20190617&quot;</td><td>&quot;20190627&quot;</td><td>3500.0</td><td>3150.0</td><td>16.29</td><td>14.18</td><td>1.4</td><td>5.702</td><td>0.03</td></tr><tr><td>&quot;600968.SH&quot;</td><td>&quot;730968&quot;</td><td>&quot;海油发展&quot;</td><td>&quot;20190614&quot;</td><td>&quot;20190626&quot;</td><td>186510.0</td><td>167859.0</td><td>2.04</td><td>22.93</td><td>55.9</td><td>38.048</td><td>0.61</td></tr><tr><td>&quot;300594.SZ&quot;</td><td>&quot;300594&quot;</td><td>&quot;朗进科技&quot;</td><td>&quot;20190612&quot;</td><td>&quot;20190621&quot;</td><td>2223.0</td><td>2000.0</td><td>19.02</td><td>22.98</td><td>0.85</td><td>4.228</td><td>0.03</td></tr><tr><td>&quot;603217.SH&quot;</td><td>&quot;732217&quot;</td><td>&quot;元利科技&quot;</td><td>&quot;20190611&quot;</td><td>&quot;20190620&quot;</td><td>2276.0</td><td>2048.0</td><td>54.96</td><td>20.72</td><td>0.9</td><td>12.509</td><td>0.03</td></tr><tr><td>&quot;603863.SH&quot;</td><td>&quot;732863&quot;</td><td>&quot;ST松炀&quot;</td><td>&quot;20190611&quot;</td><td>&quot;20190621&quot;</td><td>5147.0</td><td>4633.0</td><td>9.95</td><td>22.69</td><td>2.0</td><td>5.122</td><td>0.04</td></tr></tbody></table></div>"
      ],
      "text/plain": [
       "shape: (2_000, 12)\n",
       "┌─────────┬─────────┬─────────┬────────┬───┬───────┬────────┬────────┬────────┐\n",
       "│ ts_code ┆ sub_cod ┆ name    ┆ ipo_da ┆ … ┆ pe    ┆ limit_ ┆ funds  ┆ ballot │\n",
       "│ ---     ┆ e       ┆ ---     ┆ te     ┆   ┆ ---   ┆ amount ┆ ---    ┆ ---    │\n",
       "│ str     ┆ ---     ┆ str     ┆ ---    ┆   ┆ f64   ┆ ---    ┆ f64    ┆ f64    │\n",
       "│         ┆ str     ┆         ┆ str    ┆   ┆       ┆ f64    ┆        ┆        │\n",
       "╞═════════╪═════════╪═════════╪════════╪═══╪═══════╪════════╪════════╪════════╡\n",
       "│ 001221. ┆ 001221  ┆ 悍高集  ┆ 202507 ┆ … ┆ 0.0   ┆ 1.05   ┆ 0.0    ┆ 0.0    │\n",
       "│ SZ      ┆         ┆ 团      ┆ 21     ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 301609. ┆ 301609  ┆ 山大电  ┆ 202507 ┆ … ┆ 19.57 ┆ 1.0    ┆ 5.97   ┆ 0.0    │\n",
       "│ SZ      ┆         ┆ 力      ┆ 14     ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 603262. ┆ 732262  ┆ 技源集  ┆ 202507 ┆ … ┆ 25.51 ┆ 1.2    ┆ 5.441  ┆ 0.0    │\n",
       "│ SH      ┆         ┆ 团      ┆ 14     ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 600930. ┆ 730930  ┆ 华电新  ┆ 202507 ┆ … ┆ 15.56 ┆ 149.05 ┆ 181.71 ┆ 0.56   │\n",
       "│ SH      ┆         ┆ 能      ┆ 07     ┆   ┆       ┆        ┆ 4      ┆        │\n",
       "│ 301630. ┆ 301630  ┆ 同宇新  ┆ 202507 ┆ … ┆ 23.94 ┆ 1.0    ┆ 8.4    ┆ 0.01   │\n",
       "│ SZ      ┆         ┆ 材      ┆ 01     ┆   ┆       ┆        ┆        ┆        │\n",
       "│ …       ┆ …       ┆ …       ┆ …      ┆ … ┆ …     ┆ …      ┆ …      ┆ …      │\n",
       "│ 603867. ┆ 732867  ┆ 新化股  ┆ 201906 ┆ … ┆ 14.18 ┆ 1.4    ┆ 5.702  ┆ 0.03   │\n",
       "│ SH      ┆         ┆ 份      ┆ 17     ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 600968. ┆ 730968  ┆ 海油发  ┆ 201906 ┆ … ┆ 22.93 ┆ 55.9   ┆ 38.048 ┆ 0.61   │\n",
       "│ SH      ┆         ┆ 展      ┆ 14     ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 300594. ┆ 300594  ┆ 朗进科  ┆ 201906 ┆ … ┆ 22.98 ┆ 0.85   ┆ 4.228  ┆ 0.03   │\n",
       "│ SZ      ┆         ┆ 技      ┆ 12     ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 603217. ┆ 732217  ┆ 元利科  ┆ 201906 ┆ … ┆ 20.72 ┆ 0.9    ┆ 12.509 ┆ 0.03   │\n",
       "│ SH      ┆         ┆ 技      ┆ 11     ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 603863. ┆ 732863  ┆ ST松炀  ┆ 201906 ┆ … ┆ 22.69 ┆ 2.0    ┆ 5.122  ┆ 0.04   │\n",
       "│ SH      ┆         ┆         ┆ 11     ┆   ┆       ┆        ┆        ┆        │\n",
       "└─────────┴─────────┴─────────┴────────┴───┴───────┴────────┴────────┴────────┘"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "3e87d6aa-1823-4499-b082-a5a1b38762cd",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><style>\n",
       ".dataframe > thead > tr,\n",
       ".dataframe > tbody > tr {\n",
       "  text-align: right;\n",
       "  white-space: pre-wrap;\n",
       "}\n",
       "</style>\n",
       "<small>shape: (5_418, 17)</small><table border=\"1\" class=\"dataframe\"><thead><tr><th>ts_code</th><th>symbol</th><th>name</th><th>area</th><th>industry</th><th>fullname</th><th>enname</th><th>cnspell</th><th>market</th><th>exchange</th><th>curr_type</th><th>list_status</th><th>list_date</th><th>delist_date</th><th>is_hs</th><th>act_name</th><th>act_ent_type</th></tr><tr><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>null</td><td>str</td><td>str</td><td>str</td></tr></thead><tbody><tr><td>&quot;000001.SZ&quot;</td><td>&quot;000001&quot;</td><td>&quot;平安银行&quot;</td><td>&quot;深圳&quot;</td><td>&quot;银行&quot;</td><td>&quot;平安银行股份有限公司&quot;</td><td>&quot;Ping An Bank Co., Ltd.&quot;</td><td>&quot;payh&quot;</td><td>&quot;主板&quot;</td><td>&quot;SZSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>&quot;19910403&quot;</td><td>null</td><td>&quot;S&quot;</td><td>&quot;无实际控制人&quot;</td><td>&quot;无&quot;</td></tr><tr><td>&quot;000002.SZ&quot;</td><td>&quot;000002&quot;</td><td>&quot;万科A&quot;</td><td>&quot;深圳&quot;</td><td>&quot;全国地产&quot;</td><td>&quot;万科企业股份有限公司&quot;</td><td>&quot;China Vanke Co.,Ltd.&quot;</td><td>&quot;wka&quot;</td><td>&quot;主板&quot;</td><td>&quot;SZSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>&quot;19910129&quot;</td><td>null</td><td>&quot;S&quot;</td><td>&quot;深圳市人民政府国有资产监督管理委员会&quot;</td><td>&quot;地方国企&quot;</td></tr><tr><td>&quot;000004.SZ&quot;</td><td>&quot;000004&quot;</td><td>&quot;*ST国华&quot;</td><td>&quot;深圳&quot;</td><td>&quot;软件服务&quot;</td><td>&quot;深圳国华网安科技股份有限公司&quot;</td><td>&quot;Shenzhen Guohua Network Securi…</td><td>&quot;stgh&quot;</td><td>&quot;主板&quot;</td><td>&quot;SZSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>&quot;19910114&quot;</td><td>null</td><td>&quot;N&quot;</td><td>&quot;李映彤&quot;</td><td>&quot;民营企业&quot;</td></tr><tr><td>&quot;000006.SZ&quot;</td><td>&quot;000006&quot;</td><td>&quot;深振业A&quot;</td><td>&quot;深圳&quot;</td><td>&quot;区域地产&quot;</td><td>&quot;深圳市振业(集团)股份有限公司&quot;</td><td>&quot;Shenzhen Zhenye(Group) Co., Lt…</td><td>&quot;szya&quot;</td><td>&quot;主板&quot;</td><td>&quot;SZSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>&quot;19920427&quot;</td><td>null</td><td>&quot;S&quot;</td><td>&quot;深圳市人民政府国有资产监督管理委员会&quot;</td><td>&quot;地方国企&quot;</td></tr><tr><td>&quot;000007.SZ&quot;</td><td>&quot;000007&quot;</td><td>&quot;全新好&quot;</td><td>&quot;深圳&quot;</td><td>&quot;其他商业&quot;</td><td>&quot;深圳市全新好股份有限公司&quot;</td><td>&quot;Shenzhen Quanxinhao Co,.Ltd.&quot;</td><td>&quot;qxh&quot;</td><td>&quot;主板&quot;</td><td>&quot;SZSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>&quot;19920413&quot;</td><td>null</td><td>&quot;N&quot;</td><td>&quot;王玩虹&quot;</td><td>&quot;民营企业&quot;</td></tr><tr><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td></tr><tr><td>&quot;920489.BJ&quot;</td><td>&quot;920489&quot;</td><td>&quot;佳先股份&quot;</td><td>&quot;安徽&quot;</td><td>&quot;化工原料&quot;</td><td>&quot;安徽佳先功能助剂股份有限公司&quot;</td><td>&quot;Anhui Jiaxian Functional Auxil…</td><td>&quot;jxgf&quot;</td><td>&quot;北交所&quot;</td><td>&quot;BSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>&quot;20200727&quot;</td><td>null</td><td>&quot;N&quot;</td><td>null</td><td>null</td></tr><tr><td>&quot;920682.BJ&quot;</td><td>&quot;920682&quot;</td><td>&quot;球冠电缆&quot;</td><td>&quot;浙江&quot;</td><td>&quot;电气设备&quot;</td><td>&quot;宁波球冠电缆股份有限公司&quot;</td><td>&quot;Ningbo Qrunning Cable Co.,Ltd&quot;</td><td>&quot;qgdl&quot;</td><td>&quot;北交所&quot;</td><td>&quot;BSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>&quot;20200727&quot;</td><td>null</td><td>&quot;N&quot;</td><td>null</td><td>null</td></tr><tr><td>&quot;920799.BJ&quot;</td><td>&quot;920799&quot;</td><td>&quot;艾融软件&quot;</td><td>&quot;上海&quot;</td><td>&quot;软件服务&quot;</td><td>&quot;上海艾融软件股份有限公司&quot;</td><td>&quot;Shanghai I2finance Technology …</td><td>&quot;arrj&quot;</td><td>&quot;北交所&quot;</td><td>&quot;BSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>&quot;20200727&quot;</td><td>null</td><td>&quot;N&quot;</td><td>null</td><td>null</td></tr><tr><td>&quot;920819.BJ&quot;</td><td>&quot;920819&quot;</td><td>&quot;颖泰生物&quot;</td><td>&quot;北京&quot;</td><td>&quot;农药化肥&quot;</td><td>&quot;北京颖泰嘉和生物科技股份有限公司&quot;</td><td>&quot;Nutrichem Company Limited&quot;</td><td>&quot;ytsw&quot;</td><td>&quot;北交所&quot;</td><td>&quot;BSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>&quot;20200727&quot;</td><td>null</td><td>&quot;N&quot;</td><td>null</td><td>null</td></tr><tr><td>&quot;689009.SH&quot;</td><td>&quot;689009&quot;</td><td>&quot;九号公司-WD&quot;</td><td>&quot;北京&quot;</td><td>&quot;摩托车&quot;</td><td>&quot;九号有限公司&quot;</td><td>&quot;Ninebot Limited&quot;</td><td>&quot;jhgs&quot;</td><td>&quot;科创板&quot;</td><td>&quot;SSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>&quot;20201029&quot;</td><td>null</td><td>null</td><td>null</td><td>null</td></tr></tbody></table></div>"
      ],
      "text/plain": [
       "shape: (5_418, 17)\n",
       "┌─────────┬────────┬─────────┬──────┬───┬─────────┬───────┬─────────┬─────────┐\n",
       "│ ts_code ┆ symbol ┆ name    ┆ area ┆ … ┆ delist_ ┆ is_hs ┆ act_nam ┆ act_ent │\n",
       "│ ---     ┆ ---    ┆ ---     ┆ ---  ┆   ┆ date    ┆ ---   ┆ e       ┆ _type   │\n",
       "│ str     ┆ str    ┆ str     ┆ str  ┆   ┆ ---     ┆ str   ┆ ---     ┆ ---     │\n",
       "│         ┆        ┆         ┆      ┆   ┆ null    ┆       ┆ str     ┆ str     │\n",
       "╞═════════╪════════╪═════════╪══════╪═══╪═════════╪═══════╪═════════╪═════════╡\n",
       "│ 000001. ┆ 000001 ┆ 平安银  ┆ 深圳 ┆ … ┆ null    ┆ S     ┆ 无实际  ┆ 无      │\n",
       "│ SZ      ┆        ┆ 行      ┆      ┆   ┆         ┆       ┆ 控制人  ┆         │\n",
       "│ 000002. ┆ 000002 ┆ 万科A   ┆ 深圳 ┆ … ┆ null    ┆ S     ┆ 深圳市  ┆ 地方国  │\n",
       "│ SZ      ┆        ┆         ┆      ┆   ┆         ┆       ┆ 人民政  ┆ 企      │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 府国有  ┆         │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 资产监  ┆         │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 督管理  ┆         │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 委员会  ┆         │\n",
       "│ 000004. ┆ 000004 ┆ *ST国华 ┆ 深圳 ┆ … ┆ null    ┆ N     ┆ 李映彤  ┆ 民营企  │\n",
       "│ SZ      ┆        ┆         ┆      ┆   ┆         ┆       ┆         ┆ 业      │\n",
       "│ 000006. ┆ 000006 ┆ 深振业A ┆ 深圳 ┆ … ┆ null    ┆ S     ┆ 深圳市  ┆ 地方国  │\n",
       "│ SZ      ┆        ┆         ┆      ┆   ┆         ┆       ┆ 人民政  ┆ 企      │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 府国有  ┆         │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 资产监  ┆         │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 督管理  ┆         │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 委员会  ┆         │\n",
       "│ 000007. ┆ 000007 ┆ 全新好  ┆ 深圳 ┆ … ┆ null    ┆ N     ┆ 王玩虹  ┆ 民营企  │\n",
       "│ SZ      ┆        ┆         ┆      ┆   ┆         ┆       ┆         ┆ 业      │\n",
       "│ …       ┆ …      ┆ …       ┆ …    ┆ … ┆ …       ┆ …     ┆ …       ┆ …       │\n",
       "│ 920489. ┆ 920489 ┆ 佳先股  ┆ 安徽 ┆ … ┆ null    ┆ N     ┆ null    ┆ null    │\n",
       "│ BJ      ┆        ┆ 份      ┆      ┆   ┆         ┆       ┆         ┆         │\n",
       "│ 920682. ┆ 920682 ┆ 球冠电  ┆ 浙江 ┆ … ┆ null    ┆ N     ┆ null    ┆ null    │\n",
       "│ BJ      ┆        ┆ 缆      ┆      ┆   ┆         ┆       ┆         ┆         │\n",
       "│ 920799. ┆ 920799 ┆ 艾融软  ┆ 上海 ┆ … ┆ null    ┆ N     ┆ null    ┆ null    │\n",
       "│ BJ      ┆        ┆ 件      ┆      ┆   ┆         ┆       ┆         ┆         │\n",
       "│ 920819. ┆ 920819 ┆ 颖泰生  ┆ 北京 ┆ … ┆ null    ┆ N     ┆ null    ┆ null    │\n",
       "│ BJ      ┆        ┆ 物      ┆      ┆   ┆         ┆       ┆         ┆         │\n",
       "│ 689009. ┆ 689009 ┆ 九号公  ┆ 北京 ┆ … ┆ null    ┆ null  ┆ null    ┆ null    │\n",
       "│ SH      ┆        ┆ 司-WD   ┆      ┆   ┆         ┆       ┆         ┆         │\n",
       "└─────────┴────────┴─────────┴──────┴───┴─────────┴───────┴─────────┴─────────┘"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "86ebc3be-799a-48af-a163-aa591f0cd434",
   "metadata": {},
   "outputs": [],
   "source": [
    "d1 = d1.with_columns(\n",
    "    ipo_date=pl.col.ipo_date.str.to_date(\"%Y%m%d\"),\n",
    "    issue_date=pl.col.issue_date.str.to_date(\"%Y%m%d\"),\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "fc07ca82-7be2-4a31-a880-121ba096e809",
   "metadata": {},
   "outputs": [],
   "source": [
    "d2 = d2.with_columns(\n",
    "    list_date=pl.col.list_date.str.to_date(\"%Y%m%d\"),\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "4964852d-fb57-4392-89db-65c576e567d7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><style>\n",
       ".dataframe > thead > tr,\n",
       ".dataframe > tbody > tr {\n",
       "  text-align: right;\n",
       "  white-space: pre-wrap;\n",
       "}\n",
       "</style>\n",
       "<small>shape: (2_000, 12)</small><table border=\"1\" class=\"dataframe\"><thead><tr><th>ts_code</th><th>sub_code</th><th>name</th><th>ipo_date</th><th>issue_date</th><th>amount</th><th>market_amount</th><th>price</th><th>pe</th><th>limit_amount</th><th>funds</th><th>ballot</th></tr><tr><td>str</td><td>str</td><td>str</td><td>date</td><td>date</td><td>f64</td><td>f64</td><td>f64</td><td>f64</td><td>f64</td><td>f64</td><td>f64</td></tr></thead><tbody><tr><td>&quot;001221.SZ&quot;</td><td>&quot;001221&quot;</td><td>&quot;悍高集团&quot;</td><td>2025-07-21</td><td>null</td><td>4001.0</td><td>0.0</td><td>0.0</td><td>0.0</td><td>1.05</td><td>0.0</td><td>0.0</td></tr><tr><td>&quot;301609.SZ&quot;</td><td>&quot;301609&quot;</td><td>&quot;山大电力&quot;</td><td>2025-07-14</td><td>null</td><td>4072.0</td><td>1038.0</td><td>14.66</td><td>19.57</td><td>1.0</td><td>5.97</td><td>0.0</td></tr><tr><td>&quot;603262.SH&quot;</td><td>&quot;732262&quot;</td><td>&quot;技源集团&quot;</td><td>2025-07-14</td><td>null</td><td>5001.0</td><td>1200.0</td><td>10.88</td><td>25.51</td><td>1.2</td><td>5.441</td><td>0.0</td></tr><tr><td>&quot;600930.SH&quot;</td><td>&quot;730930&quot;</td><td>&quot;华电新能&quot;</td><td>2025-07-07</td><td>null</td><td>571429.0</td><td>144928.0</td><td>3.18</td><td>15.56</td><td>149.05</td><td>181.714</td><td>0.56</td></tr><tr><td>&quot;301630.SZ&quot;</td><td>&quot;301630&quot;</td><td>&quot;同宇新材&quot;</td><td>2025-07-01</td><td>2025-07-10</td><td>1000.0</td><td>1000.0</td><td>84.0</td><td>23.94</td><td>1.0</td><td>8.4</td><td>0.01</td></tr><tr><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td></tr><tr><td>&quot;603867.SH&quot;</td><td>&quot;732867&quot;</td><td>&quot;新化股份&quot;</td><td>2019-06-17</td><td>2019-06-27</td><td>3500.0</td><td>3150.0</td><td>16.29</td><td>14.18</td><td>1.4</td><td>5.702</td><td>0.03</td></tr><tr><td>&quot;600968.SH&quot;</td><td>&quot;730968&quot;</td><td>&quot;海油发展&quot;</td><td>2019-06-14</td><td>2019-06-26</td><td>186510.0</td><td>167859.0</td><td>2.04</td><td>22.93</td><td>55.9</td><td>38.048</td><td>0.61</td></tr><tr><td>&quot;300594.SZ&quot;</td><td>&quot;300594&quot;</td><td>&quot;朗进科技&quot;</td><td>2019-06-12</td><td>2019-06-21</td><td>2223.0</td><td>2000.0</td><td>19.02</td><td>22.98</td><td>0.85</td><td>4.228</td><td>0.03</td></tr><tr><td>&quot;603217.SH&quot;</td><td>&quot;732217&quot;</td><td>&quot;元利科技&quot;</td><td>2019-06-11</td><td>2019-06-20</td><td>2276.0</td><td>2048.0</td><td>54.96</td><td>20.72</td><td>0.9</td><td>12.509</td><td>0.03</td></tr><tr><td>&quot;603863.SH&quot;</td><td>&quot;732863&quot;</td><td>&quot;ST松炀&quot;</td><td>2019-06-11</td><td>2019-06-21</td><td>5147.0</td><td>4633.0</td><td>9.95</td><td>22.69</td><td>2.0</td><td>5.122</td><td>0.04</td></tr></tbody></table></div>"
      ],
      "text/plain": [
       "shape: (2_000, 12)\n",
       "┌─────────┬─────────┬─────────┬────────┬───┬───────┬────────┬────────┬────────┐\n",
       "│ ts_code ┆ sub_cod ┆ name    ┆ ipo_da ┆ … ┆ pe    ┆ limit_ ┆ funds  ┆ ballot │\n",
       "│ ---     ┆ e       ┆ ---     ┆ te     ┆   ┆ ---   ┆ amount ┆ ---    ┆ ---    │\n",
       "│ str     ┆ ---     ┆ str     ┆ ---    ┆   ┆ f64   ┆ ---    ┆ f64    ┆ f64    │\n",
       "│         ┆ str     ┆         ┆ date   ┆   ┆       ┆ f64    ┆        ┆        │\n",
       "╞═════════╪═════════╪═════════╪════════╪═══╪═══════╪════════╪════════╪════════╡\n",
       "│ 001221. ┆ 001221  ┆ 悍高集  ┆ 2025-0 ┆ … ┆ 0.0   ┆ 1.05   ┆ 0.0    ┆ 0.0    │\n",
       "│ SZ      ┆         ┆ 团      ┆ 7-21   ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 301609. ┆ 301609  ┆ 山大电  ┆ 2025-0 ┆ … ┆ 19.57 ┆ 1.0    ┆ 5.97   ┆ 0.0    │\n",
       "│ SZ      ┆         ┆ 力      ┆ 7-14   ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 603262. ┆ 732262  ┆ 技源集  ┆ 2025-0 ┆ … ┆ 25.51 ┆ 1.2    ┆ 5.441  ┆ 0.0    │\n",
       "│ SH      ┆         ┆ 团      ┆ 7-14   ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 600930. ┆ 730930  ┆ 华电新  ┆ 2025-0 ┆ … ┆ 15.56 ┆ 149.05 ┆ 181.71 ┆ 0.56   │\n",
       "│ SH      ┆         ┆ 能      ┆ 7-07   ┆   ┆       ┆        ┆ 4      ┆        │\n",
       "│ 301630. ┆ 301630  ┆ 同宇新  ┆ 2025-0 ┆ … ┆ 23.94 ┆ 1.0    ┆ 8.4    ┆ 0.01   │\n",
       "│ SZ      ┆         ┆ 材      ┆ 7-01   ┆   ┆       ┆        ┆        ┆        │\n",
       "│ …       ┆ …       ┆ …       ┆ …      ┆ … ┆ …     ┆ …      ┆ …      ┆ …      │\n",
       "│ 603867. ┆ 732867  ┆ 新化股  ┆ 2019-0 ┆ … ┆ 14.18 ┆ 1.4    ┆ 5.702  ┆ 0.03   │\n",
       "│ SH      ┆         ┆ 份      ┆ 6-17   ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 600968. ┆ 730968  ┆ 海油发  ┆ 2019-0 ┆ … ┆ 22.93 ┆ 55.9   ┆ 38.048 ┆ 0.61   │\n",
       "│ SH      ┆         ┆ 展      ┆ 6-14   ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 300594. ┆ 300594  ┆ 朗进科  ┆ 2019-0 ┆ … ┆ 22.98 ┆ 0.85   ┆ 4.228  ┆ 0.03   │\n",
       "│ SZ      ┆         ┆ 技      ┆ 6-12   ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 603217. ┆ 732217  ┆ 元利科  ┆ 2019-0 ┆ … ┆ 20.72 ┆ 0.9    ┆ 12.509 ┆ 0.03   │\n",
       "│ SH      ┆         ┆ 技      ┆ 6-11   ┆   ┆       ┆        ┆        ┆        │\n",
       "│ 603863. ┆ 732863  ┆ ST松炀  ┆ 2019-0 ┆ … ┆ 22.69 ┆ 2.0    ┆ 5.122  ┆ 0.04   │\n",
       "│ SH      ┆         ┆         ┆ 6-11   ┆   ┆       ┆        ┆        ┆        │\n",
       "└─────────┴─────────┴─────────┴────────┴───┴───────┴────────┴────────┴────────┘"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "ab1d3d2f-c81c-420f-bdf3-911cb24ff1d3",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><style>\n",
       ".dataframe > thead > tr,\n",
       ".dataframe > tbody > tr {\n",
       "  text-align: right;\n",
       "  white-space: pre-wrap;\n",
       "}\n",
       "</style>\n",
       "<small>shape: (5_418, 17)</small><table border=\"1\" class=\"dataframe\"><thead><tr><th>ts_code</th><th>symbol</th><th>name</th><th>area</th><th>industry</th><th>fullname</th><th>enname</th><th>cnspell</th><th>market</th><th>exchange</th><th>curr_type</th><th>list_status</th><th>list_date</th><th>delist_date</th><th>is_hs</th><th>act_name</th><th>act_ent_type</th></tr><tr><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>date</td><td>null</td><td>str</td><td>str</td><td>str</td></tr></thead><tbody><tr><td>&quot;000001.SZ&quot;</td><td>&quot;000001&quot;</td><td>&quot;平安银行&quot;</td><td>&quot;深圳&quot;</td><td>&quot;银行&quot;</td><td>&quot;平安银行股份有限公司&quot;</td><td>&quot;Ping An Bank Co., Ltd.&quot;</td><td>&quot;payh&quot;</td><td>&quot;主板&quot;</td><td>&quot;SZSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>1991-04-03</td><td>null</td><td>&quot;S&quot;</td><td>&quot;无实际控制人&quot;</td><td>&quot;无&quot;</td></tr><tr><td>&quot;000002.SZ&quot;</td><td>&quot;000002&quot;</td><td>&quot;万科A&quot;</td><td>&quot;深圳&quot;</td><td>&quot;全国地产&quot;</td><td>&quot;万科企业股份有限公司&quot;</td><td>&quot;China Vanke Co.,Ltd.&quot;</td><td>&quot;wka&quot;</td><td>&quot;主板&quot;</td><td>&quot;SZSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>1991-01-29</td><td>null</td><td>&quot;S&quot;</td><td>&quot;深圳市人民政府国有资产监督管理委员会&quot;</td><td>&quot;地方国企&quot;</td></tr><tr><td>&quot;000004.SZ&quot;</td><td>&quot;000004&quot;</td><td>&quot;*ST国华&quot;</td><td>&quot;深圳&quot;</td><td>&quot;软件服务&quot;</td><td>&quot;深圳国华网安科技股份有限公司&quot;</td><td>&quot;Shenzhen Guohua Network Securi…</td><td>&quot;stgh&quot;</td><td>&quot;主板&quot;</td><td>&quot;SZSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>1991-01-14</td><td>null</td><td>&quot;N&quot;</td><td>&quot;李映彤&quot;</td><td>&quot;民营企业&quot;</td></tr><tr><td>&quot;000006.SZ&quot;</td><td>&quot;000006&quot;</td><td>&quot;深振业A&quot;</td><td>&quot;深圳&quot;</td><td>&quot;区域地产&quot;</td><td>&quot;深圳市振业(集团)股份有限公司&quot;</td><td>&quot;Shenzhen Zhenye(Group) Co., Lt…</td><td>&quot;szya&quot;</td><td>&quot;主板&quot;</td><td>&quot;SZSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>1992-04-27</td><td>null</td><td>&quot;S&quot;</td><td>&quot;深圳市人民政府国有资产监督管理委员会&quot;</td><td>&quot;地方国企&quot;</td></tr><tr><td>&quot;000007.SZ&quot;</td><td>&quot;000007&quot;</td><td>&quot;全新好&quot;</td><td>&quot;深圳&quot;</td><td>&quot;其他商业&quot;</td><td>&quot;深圳市全新好股份有限公司&quot;</td><td>&quot;Shenzhen Quanxinhao Co,.Ltd.&quot;</td><td>&quot;qxh&quot;</td><td>&quot;主板&quot;</td><td>&quot;SZSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>1992-04-13</td><td>null</td><td>&quot;N&quot;</td><td>&quot;王玩虹&quot;</td><td>&quot;民营企业&quot;</td></tr><tr><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td></tr><tr><td>&quot;920489.BJ&quot;</td><td>&quot;920489&quot;</td><td>&quot;佳先股份&quot;</td><td>&quot;安徽&quot;</td><td>&quot;化工原料&quot;</td><td>&quot;安徽佳先功能助剂股份有限公司&quot;</td><td>&quot;Anhui Jiaxian Functional Auxil…</td><td>&quot;jxgf&quot;</td><td>&quot;北交所&quot;</td><td>&quot;BSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>2020-07-27</td><td>null</td><td>&quot;N&quot;</td><td>null</td><td>null</td></tr><tr><td>&quot;920682.BJ&quot;</td><td>&quot;920682&quot;</td><td>&quot;球冠电缆&quot;</td><td>&quot;浙江&quot;</td><td>&quot;电气设备&quot;</td><td>&quot;宁波球冠电缆股份有限公司&quot;</td><td>&quot;Ningbo Qrunning Cable Co.,Ltd&quot;</td><td>&quot;qgdl&quot;</td><td>&quot;北交所&quot;</td><td>&quot;BSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>2020-07-27</td><td>null</td><td>&quot;N&quot;</td><td>null</td><td>null</td></tr><tr><td>&quot;920799.BJ&quot;</td><td>&quot;920799&quot;</td><td>&quot;艾融软件&quot;</td><td>&quot;上海&quot;</td><td>&quot;软件服务&quot;</td><td>&quot;上海艾融软件股份有限公司&quot;</td><td>&quot;Shanghai I2finance Technology …</td><td>&quot;arrj&quot;</td><td>&quot;北交所&quot;</td><td>&quot;BSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>2020-07-27</td><td>null</td><td>&quot;N&quot;</td><td>null</td><td>null</td></tr><tr><td>&quot;920819.BJ&quot;</td><td>&quot;920819&quot;</td><td>&quot;颖泰生物&quot;</td><td>&quot;北京&quot;</td><td>&quot;农药化肥&quot;</td><td>&quot;北京颖泰嘉和生物科技股份有限公司&quot;</td><td>&quot;Nutrichem Company Limited&quot;</td><td>&quot;ytsw&quot;</td><td>&quot;北交所&quot;</td><td>&quot;BSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>2020-07-27</td><td>null</td><td>&quot;N&quot;</td><td>null</td><td>null</td></tr><tr><td>&quot;689009.SH&quot;</td><td>&quot;689009&quot;</td><td>&quot;九号公司-WD&quot;</td><td>&quot;北京&quot;</td><td>&quot;摩托车&quot;</td><td>&quot;九号有限公司&quot;</td><td>&quot;Ninebot Limited&quot;</td><td>&quot;jhgs&quot;</td><td>&quot;科创板&quot;</td><td>&quot;SSE&quot;</td><td>&quot;CNY&quot;</td><td>&quot;L&quot;</td><td>2020-10-29</td><td>null</td><td>null</td><td>null</td><td>null</td></tr></tbody></table></div>"
      ],
      "text/plain": [
       "shape: (5_418, 17)\n",
       "┌─────────┬────────┬─────────┬──────┬───┬─────────┬───────┬─────────┬─────────┐\n",
       "│ ts_code ┆ symbol ┆ name    ┆ area ┆ … ┆ delist_ ┆ is_hs ┆ act_nam ┆ act_ent │\n",
       "│ ---     ┆ ---    ┆ ---     ┆ ---  ┆   ┆ date    ┆ ---   ┆ e       ┆ _type   │\n",
       "│ str     ┆ str    ┆ str     ┆ str  ┆   ┆ ---     ┆ str   ┆ ---     ┆ ---     │\n",
       "│         ┆        ┆         ┆      ┆   ┆ null    ┆       ┆ str     ┆ str     │\n",
       "╞═════════╪════════╪═════════╪══════╪═══╪═════════╪═══════╪═════════╪═════════╡\n",
       "│ 000001. ┆ 000001 ┆ 平安银  ┆ 深圳 ┆ … ┆ null    ┆ S     ┆ 无实际  ┆ 无      │\n",
       "│ SZ      ┆        ┆ 行      ┆      ┆   ┆         ┆       ┆ 控制人  ┆         │\n",
       "│ 000002. ┆ 000002 ┆ 万科A   ┆ 深圳 ┆ … ┆ null    ┆ S     ┆ 深圳市  ┆ 地方国  │\n",
       "│ SZ      ┆        ┆         ┆      ┆   ┆         ┆       ┆ 人民政  ┆ 企      │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 府国有  ┆         │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 资产监  ┆         │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 督管理  ┆         │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 委员会  ┆         │\n",
       "│ 000004. ┆ 000004 ┆ *ST国华 ┆ 深圳 ┆ … ┆ null    ┆ N     ┆ 李映彤  ┆ 民营企  │\n",
       "│ SZ      ┆        ┆         ┆      ┆   ┆         ┆       ┆         ┆ 业      │\n",
       "│ 000006. ┆ 000006 ┆ 深振业A ┆ 深圳 ┆ … ┆ null    ┆ S     ┆ 深圳市  ┆ 地方国  │\n",
       "│ SZ      ┆        ┆         ┆      ┆   ┆         ┆       ┆ 人民政  ┆ 企      │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 府国有  ┆         │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 资产监  ┆         │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 督管理  ┆         │\n",
       "│         ┆        ┆         ┆      ┆   ┆         ┆       ┆ 委员会  ┆         │\n",
       "│ 000007. ┆ 000007 ┆ 全新好  ┆ 深圳 ┆ … ┆ null    ┆ N     ┆ 王玩虹  ┆ 民营企  │\n",
       "│ SZ      ┆        ┆         ┆      ┆   ┆         ┆       ┆         ┆ 业      │\n",
       "│ …       ┆ …      ┆ …       ┆ …    ┆ … ┆ …       ┆ …     ┆ …       ┆ …       │\n",
       "│ 920489. ┆ 920489 ┆ 佳先股  ┆ 安徽 ┆ … ┆ null    ┆ N     ┆ null    ┆ null    │\n",
       "│ BJ      ┆        ┆ 份      ┆      ┆   ┆         ┆       ┆         ┆         │\n",
       "│ 920682. ┆ 920682 ┆ 球冠电  ┆ 浙江 ┆ … ┆ null    ┆ N     ┆ null    ┆ null    │\n",
       "│ BJ      ┆        ┆ 缆      ┆      ┆   ┆         ┆       ┆         ┆         │\n",
       "│ 920799. ┆ 920799 ┆ 艾融软  ┆ 上海 ┆ … ┆ null    ┆ N     ┆ null    ┆ null    │\n",
       "│ BJ      ┆        ┆ 件      ┆      ┆   ┆         ┆       ┆         ┆         │\n",
       "│ 920819. ┆ 920819 ┆ 颖泰生  ┆ 北京 ┆ … ┆ null    ┆ N     ┆ null    ┆ null    │\n",
       "│ BJ      ┆        ┆ 物      ┆      ┆   ┆         ┆       ┆         ┆         │\n",
       "│ 689009. ┆ 689009 ┆ 九号公  ┆ 北京 ┆ … ┆ null    ┆ null  ┆ null    ┆ null    │\n",
       "│ SH      ┆        ┆ 司-WD   ┆      ┆   ┆         ┆       ┆         ┆         │\n",
       "└─────────┴────────┴─────────┴──────┴───┴─────────┴───────┴─────────┴─────────┘"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "297b95fe-1572-4736-9734-14dbd6b458d3",
   "metadata": {},
   "outputs": [],
   "source": [
    "config = '{\"version\":\"3.7.2\",\"plugin\":\"Datagrid\",\"plugin_config\":{\"columns\":{\"price\":{\"column_size_override\":1}},\"edit_mode\":\"READ_ONLY\",\"scroll_lock\":false},\"columns_config\":{\"name\":{\"color\":\"#5888ad\"},\"amount\":{\"number_fg_mode\":\"disabled\",\"number_format\":{\"minimumFractionDigits\":0.0,\"maximumFractionDigits\":2.0}},\"ipo_date\":{\"date_format\":{\"dateStyle\":\"disabled\"}}},\"settings\":true,\"theme\":\"Pro Light\",\"title\":null,\"group_by\":[],\"split_by\":[],\"sort\":[[\"limit_amount\",\"desc\"]],\"filter\":[],\"expressions\":{\"market_ratio\":\"\\\"market_amount\\\"/\\\"amount\\\"\"},\"columns\":[\"ts_code\",\"sub_code\",\"name\",\"ipo_date\",\"issue_date\",\"amount\",\"market_amount\",\"market_ratio\",\"price\",\"pe\",\"limit_amount\",\"funds\",\"ballot\"],\"aggregates\":{}}'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "22f519ed-02bb-4e33-b5bf-1d5a296f0aeb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\"version\":\"3.7.2\",\"plugin\":\"Datagrid\",\"plugin_config\":{\"columns\":{\"price\":{\"column_size_override\":1}},\"edit_mode\":\"READ_ONLY\",\"scroll_lock\":false},\"columns_config\":{\"name\":{\"color\":\"#5888ad\"},\"amount\":{\"number_fg_mode\":\"disabled\",\"number_format\":{\"minimumFractionDigits\":0.0,\"maximumFractionDigits\":2.0}},\"ipo_date\":{\"date_format\":{\"dateStyle\":\"disabled\"}}},\"settings\":true,\"theme\":\"Pro Light\",\"title\":null,\"group_by\":[],\"split_by\":[],\"sort\":[[\"limit_amount\",\"desc\"]],\"filter\":[],\"expressions\":{\"market_ratio\":\"\"market_amount\"/\"amount\"\"},\"columns\":[\"ts_code\",\"sub_code\",\"name\",\"ipo_date\",\"issue_date\",\"amount\",\"market_amount\",\"market_ratio\",\"price\",\"pe\",\"limit_amount\",\"funds\",\"ballot\"],\"aggregates\":{}}\n"
     ]
    }
   ],
   "source": [
    "print(config)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "1e764ab7-919a-4b10-b2e8-5f37c6ac271d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "30cc54f5777a4f4894af861eb477de7d",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "PerspectiveWidget(binding_mode='server', columns=['ts_code', 'sub_code', 'name', 'ipo_date', 'issue_date', 'am…"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "PerspectiveWidget(d1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "03ac348b-e34c-4910-a7c6-1d88ed75aa85",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "99befee1530a4ec39ab68825da88cf29",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "PerspectiveWidget(binding_mode='server', columns=['ts_code', 'symbol', 'name', 'area', 'industry', 'fullname',…"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "PerspectiveWidget(d2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0583f700-5bbb-478f-a940-e3aa61334c92",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
